package com.it.dao;


import com.it.Bean.sys_user;

import java.util.List;

public interface Sys_userDao {

    /**
     *  //查询一个
     *  sql select * from sys_user where id=?
     * @param id
     * @return
     */
    public sys_user queryById(Integer id);
    //查询所有

    /**
     * 查询所有
     * sql select * from sys_user
     * @return List<sys_user>
     */
    public List<sys_user> getQueryAll();

    /**
     *  //添加
     *  sql insert into sys_user(name,sex,age,marryed,ad,tel) values(?,?,?,?,?,?)
     * @param user
     * @return
     */
    public boolean save(sys_user user);


    /**
     *  //修改
     *  sql update sys_user set name=?,sex=?,age=?,marryed=?,ad=?,tel=? where id=?
     * @param user
     * @return
     */
    public boolean update(sys_user user);


    /**
     * //删除
     * sql delete from sys_user where id=?
     * @param id
     * @return
     */
    public boolean delete(Integer id);
}
